/**
 * 
 */
package com.owen.he.jee.utils.excel;

import java.util.HashMap;
import java.util.Map;

/**
 * @author chenly 
 *
 * @version createtime:2016-10-13 上午10:49:58 
 */
public class YjdrMapUtils {

	public static Map<String,String> map = new HashMap<String,String>(){{
		put("jjyjdr","基金业绩导入管理");
		put("bxyjdr", "保险业绩导入管理");
		put("dfgzyjdr", "代发工资业绩导入管理");
		put("dsfcgyjdr", "第三方存管业绩导入管理");
		put("dxtyjpldr", "短信通业绩导入管理");
		put("gjywyjdr", "国际业务业绩导入管理");
		put("kyjgxdr", "卡业绩关系导入管理");//
		put("lcyjdr", "理财业绩导入管理");
		
		put("POSShyjdr", "POS商户导入管理");
		put("sjyhyjdr", "手机银行业绩导入管理");
		put("wsyhyjdr", "网上银行业绩导入管理");
		put("hyyjgxdrck","存款业绩关系导入管理");
		put("hyyjgxdrdk","贷款业绩关系导入管理");//有子帐号
		put("hyyjgxdrck1","存款业绩关系导入管理");
		put("hyyjgxdrdk1","贷款业绩关系导入管理");//有子帐号
		
		put("dkzryjdr","贷款责任业绩关系导入管理");
		
		put("zbpz","指标配置");
	}};     
	
	public static Map<String,String[]> headMap = new HashMap<String,String[]>(){
		{
			put("jjyjdr",new String[]{ "0_jjzh_基金账号","1_qyrq_签约日期","2_fprq_分配日期",
				"3_hydh1_分配行员1(行员工号)", "4_zlbl1_分配比例1", "5_hydh2_分配行员2(行员工号)", "6_zlbl2_分配比例2", 
				"7_hydh3_分配行员3(行员工号)", "8_zlbl3_分配比例3", "9_hydh4_分配行员4(行员工号)", "10_zlbl4_分配比例4", 
				"11_hydh5_分配行员5(行员工号)", "12_zlbl5_分配比例5", "13_hydh6_分配行员6(行员工号)", "14_zlbl6_分配比例6", 
				"15_hydh7_分配行员7(行员工号)", "16_zlbl7_分配比例7", "17_hydh8_分配行员8(行员工号)",	"18_zlbl8_分配比例8", 
				"19_hydh9_分配行员9(行员工号)", "20_zlbl9_分配比例9", "21_hydh10_分配行员10(行员工号)", "22_zlbl10_分配比例10"});
			
			put("bxyjdr",new String[]{ "0_lsh_流水号","1_jyrq_交易日期","2_fprq_分配日期",
					"3_hydh1_分配行员1(行员工号)", "4_zlbl1_分配比例1", "5_hydh2_分配行员2(行员工号)", "6_zlbl2_分配比例2", 
					"7_hydh3_分配行员3(行员工号)", "8_zlbl3_分配比例3", "9_hydh4_分配行员4(行员工号)", "10_zlbl4_分配比例4", 
					"11_hydh5_分配行员5(行员工号)", "12_zlbl5_分配比例5", "13_hydh6_分配行员6(行员工号)", "14_zlbl6_分配比例6", 
					"15_hydh7_分配行员7(行员工号)", "16_zlbl7_分配比例7", "17_hydh8_分配行员8(行员工号)",	"18_zlbl8_分配比例8", 
					"19_hydh9_分配行员9(行员工号)", "20_zlbl9_分配比例9", "21_hydh10_分配行员10(行员工号)", "22_zlbl10_分配比例10"});
			put("dfgzyjdr",new String[]{ "0_djbh_登记编号","1_qyrq_签约日期","2_fprq_分配日期",
					"3_hydh1_分配行员1(行员工号)", "4_zlbl1_分配比例1", "5_hydh2_分配行员2(行员工号)", "6_zlbl2_分配比例2", 
					"7_hydh3_分配行员3(行员工号)", "8_zlbl3_分配比例3", "9_hydh4_分配行员4(行员工号)", "10_zlbl4_分配比例4"});
			
			put("dsfcgyjdr",new String[]{ "0_khh_客户号","1_khmc_客户名称","2_qyrq_签约日期","3_fprq_分配日期",
					"4_hydh1_分配行员1(行员工号)", "5_zlbl1_分配比例1", "6_hydh2_分配行员2(行员工号)", "7_zlbl2_分配比例2", 
					"8_hydh3_分配行员3(行员工号)", "9_zlbl3_分配比例3", "10_hydh4_分配行员4(行员工号)", "11_zlbl4_分配比例4", 
					"12_hydh5_分配行员5(行员工号)", "13_zlbl5_分配比例5", "14_hydh6_分配行员6(行员工号)", "15_zlbl6_分配比例6", 
					"16_hydh7_分配行员7(行员工号)", "17_zlbl7_分配比例7", "18_hydh8_分配行员8(行员工号)",	"19_zlbl8_分配比例8", 
					"20_hydh9_分配行员9(行员工号)", "21_zlbl9_分配比例9", "22_hydh10_分配行员10(行员工号)", "23_zlbl10_分配比例10"});
			
			put("dxtyjpldr",new String[]{ "0_hth_合同号","1_khmc_客户名称","2_qyrq_签约日期","3_fprq_分配日期",
					"4_hydh1_分配行员1(行员工号)", "5_zlbl1_分配比例1", "6_hydh2_分配行员2(行员工号)", "7_zlbl2_分配比例2", 
					"8_hydh3_分配行员3(行员工号)", "9_zlbl3_分配比例3", "10_hydh4_分配行员4(行员工号)", "11_zlbl4_分配比例4"});
			
			put("gjywyjdr",new String[]{ "0_khh_客户号","1_khrq_开户日期","2_fprq_分配日期",
					"3_hydh1_分配行员1(行员工号)", "4_zlbl1_分配比例1", "5_hydh2_分配行员2(行员工号)", "6_zlbl2_分配比例2", 
					"7_hydh3_分配行员3(行员工号)", "8_zlbl3_分配比例3", "9_hydh4_分配行员4(行员工号)", "10_zlbl4_分配比例4"});
			
			put("kyjgxdr",new String[]{ "0_kh_卡号", "1_khkkrq_开卡日期",  "2_fprq_分配日期",
					"3_hydh1_分配行员1(行员工号)", "4_zlbl1_分配比例1", "5_hydh2_分配行员2(行员工号)", "6_zlbl2_分配比例2", 
					"7_hydh3_分配行员3(行员工号)", "8_zlbl3_分配比例3", "9_hydh4_分配行员4(行员工号)", "10_zlbl4_分配比例4", 
					"11_hydh5_分配行员5(行员工号)", "12_zlbl5_分配比例5", "13_hydh6_分配行员6(行员工号)", "14_zlbl6_分配比例6", 
					"15_hydh7_分配行员7(行员工号)", "16_zlbl7_分配比例7", "17_hydh8_分配行员8(行员工号)",	"18_zlbl8_分配比例8", 
					"19_hydh9_分配行员9(行员工号)", "20_zlbl9_分配比例9", "21_hydh10_分配行员10(行员工号)", "22_zlbl10_分配比例10" });
			put("lcyjdr",new String[]{ "0_lsh_流水号","1_jyrq_交易日期","2_fprq_分配日期",
					"3_hydh1_分配行员1(行员工号)", "4_zlbl1_分配比例1", "5_hydh2_分配行员2(行员工号)", "6_zlbl2_分配比例2", 
					"7_hydh3_分配行员3(行员工号)", "8_zlbl3_分配比例3", "9_hydh4_分配行员4(行员工号)", "10_zlbl4_分配比例4", 
					"11_hydh5_分配行员5(行员工号)", "12_zlbl5_分配比例5", "13_hydh6_分配行员6(行员工号)", "14_zlbl6_分配比例6", 
					"15_hydh7_分配行员7(行员工号)", "16_zlbl7_分配比例7", "17_hydh8_分配行员8(行员工号)",	"18_zlbl8_分配比例8", 
					"19_hydh9_分配行员9(行员工号)", "20_zlbl9_分配比例9", "21_hydh10_分配行员10(行员工号)", "22_zlbl10_分配比例10"});
			put("POSShyjdr",new String[]{ "0_shdh_商户代号","1_qyrq_签约日期","2_fprq_分配日期",
					"3_hydh1_分配行员1(行员工号)", "4_zlbl1_分配比例1", "5_hydh2_分配行员2(行员工号)", "6_zlbl2_分配比例2", 
					"7_hydh3_分配行员3(行员工号)", "8_zlbl3_分配比例3", "9_hydh4_分配行员4(行员工号)", "10_zlbl4_分配比例4"});
			
			put("sjyhyjdr",new String[]{ "0_hth_合同号/客户号","1_khmc_客户名称","2_qyrq_签约日期","3_fprq_分配日期",
					"4_hydh1_分配行员1(行员工号)", "5_zlbl1_分配比例1", "6_hydh2_分配行员2(行员工号)", "7_zlbl2_分配比例2", 
					"8_hydh3_分配行员3(行员工号)", "9_zlbl3_分配比例3", "10_hydh4_分配行员4(行员工号)", "11_zlbl4_分配比例4"});
			
			put("wsyhyjdr",new String[]{ "0_hth_合同号/客户号","1_khmc_客户名称","2_qyrq_签约日期","3_fprq_分配日期",
					"4_hydh1_分配行员1(行员工号)", "5_zlbl1_分配比例1", "6_hydh2_分配行员2(行员工号)", "7_zlbl2_分配比例2", 
					"8_hydh3_分配行员3(行员工号)", "9_zlbl3_分配比例3", "10_hydh4_分配行员4(行员工号)", "11_zlbl4_分配比例4"});
			
			put("hyyjgxdrck",new String[] { "0_zhdh_账号", "1_zhmc_账户名称", "2_zhye_账户余额", "3_khrq_开户日期(存款)", "4_qsrq_分配日期",
					"5_hydh1_分配行员1(行员工号)", "6_zlbl1_分配比例1", "7_hydh2_分配行员2(行员工号)", "8_zlbl2_分配比例2", "9_hydh3_分配行员3(行员工号)",
					"10_zlbl3_分配比例3", "11_hydh4_分配行员4(行员工号)", "12_zlbl4_分配比例4", "13_hydh5_分配行员5(行员工号)", "14_zlbl5_分配比例5",
					"15_hydh6_分配行员6(行员工号)", "16_zlbl6_分配比例6", "17_hydh7_分配行员7(行员工号)", "18_zlbl7_分配比例7", "19_hydh8_分配行员8(行员工号)",
					"20_zlbl8_分配比例8", "21_hydh9_分配行员9(行员工号)", "22_zlbl9_分配比例9", "23_hydh10_分配行员10(行员工号)", "24_zlbl10_分配比例10" });
			put("hyyjgxdrdk",new String[] { "0_zhdh_账号", "1_zhmc_账户名称", "2_zhye_账户余额", "3_ffrq_发放日期(贷款)", "4_qsrq_分配日期",
					"5_hydh1_分配行员1(行员工号)", "6_zlbl1_分配比例1", "7_hydh2_分配行员2(行员工号)", "8_zlbl2_分配比例2", "9_hydh3_分配行员3(行员工号)",
					"10_zlbl3_分配比例3", "11_hydh4_分配行员4(行员工号)", "12_zlbl4_分配比例4", "13_hydh5_分配行员5(行员工号)", "14_zlbl5_分配比例5",
					"15_hydh6_分配行员6(行员工号)", "16_zlbl6_分配比例6", "17_hydh7_分配行员7(行员工号)", "18_zlbl7_分配比例7", "19_hydh8_分配行员8(行员工号)",
					"20_zlbl8_分配比例8", "21_hydh9_分配行员9(行员工号)", "22_zlbl9_分配比例9", "23_hydh10_分配行员10(行员工号)", "24_zlbl10_分配比例10" });
			
			put("hyyjgxdrck1",new String[]{ "0_zhdh_账号", "1_zzh_子账号","2_zhmc_账户名称", "3_zhye_账户余额", "4_khrq_开户日期(存款)", "5_qsrq_分配日期",
					"6_hydh1_分配行员1(行员工号)", "7_zlbl1_分配比例1", "8_hydh2_分配行员2(行员工号)", "9_zlbl2_分配比例2", "10_hydh3_分配行员3(行员工号)",
					"11_zlbl3_分配比例3", "12_hydh4_分配行员4(行员工号)", "13_zlbl4_分配比例4", "14_hydh5_分配行员5(行员工号)", "15_zlbl5_分配比例5",
					"16_hydh6_分配行员6(行员工号)", "17_zlbl6_分配比例6", "18_hydh7_分配行员7(行员工号)", "19_zlbl7_分配比例7", "20_hydh8_分配行员8(行员工号)",
					"21_zlbl8_分配比例8", "22_hydh9_分配行员9(行员工号)", "23_zlbl9_分配比例9", "24_hydh10_分配行员10(行员工号)", "25_zlbl10_分配比例10" });
			put("hyyjgxdrdk1",new String[]{ "0_zhdh_账号", "1_zzh_子账号","2_zhmc_账户名称", "3_zhye_账户余额", "4_ffrq_发放日期(贷款)", "5_qsrq_分配日期",
					"6_hydh1_分配行员1(行员工号)", "7_zlbl1_分配比例1", "8_hydh2_分配行员2(行员工号)", "9_zlbl2_分配比例2", "10_hydh3_分配行员3(行员工号)",
					"11_zlbl3_分配比例3", "12_hydh4_分配行员4(行员工号)", "13_zlbl4_分配比例4", "14_hydh5_分配行员5(行员工号)", "15_zlbl5_分配比例5",
					"16_hydh6_分配行员6(行员工号)", "17_zlbl6_分配比例6", "18_hydh7_分配行员7(行员工号)", "19_zlbl7_分配比例7", "20_hydh8_分配行员8(行员工号)",
					"21_zlbl8_分配比例8", "22_hydh9_分配行员9(行员工号)", "23_zlbl9_分配比例9", "24_hydh10_分配行员10(行员工号)", "25_zlbl10_分配比例10" });
			
			put("dkzryjdr",new String[]{ "0_zhdh_账号", "1_zhmc_账户名称", "2_zhye_账户余额", "3_qsrq_开户日期(存款)/发放日期(贷款)", "4_ffrq_分配日期",
					"5_hydh1_分配行员1(行员工号)", "6_zlbl1_分配比例1", "7_hydh2_分配行员2(行员工号)", "8_zlbl2_分配比例2", "9_hydh3_分配行员3(行员工号)",
					"10_zlbl3_分配比例3", "11_hydh4_分配行员4(行员工号)", "12_zlbl4_分配比例4", "13_hydh5_分配行员5(行员工号)", "14_zlbl5_分配比例5",
					"15_hydh6_分配行员6(行员工号)", "16_zlbl6_分配比例6", "17_hydh7_分配行员7(行员工号)", "18_zlbl7_分配比例7", "19_hydh8_分配行员8(行员工号)",
					"20_zlbl8_分配比例8", "21_hydh9_分配行员9(行员工号)", "22_zlbl9_分配比例9", "23_hydh10_分配行员10(行员工号)", "24_zlbl10_分配比例10" });
		
		    put("zbpz",new String[]{ "0_ywlb_业务类别", "1_ddlb_调度类别", "2_zbmcdj_指标名称递进", "3_zbdh_指标代号", "4_zbpx_排序", "5_kmjs_科目组成/计算方法",
					"6_sjb_数据表", "7_qzzd_取值字段", "8_sjly_数据来源", "9_sjzb_上级指标", "10_zbcc_指标层次", "11_zbdw_指标单位", "12_sd_时段", "13_bz_币种",
					"14_tjkj_统计口径", "15_tjcx_统计程序", "16_jspl_计算频率" });
		}
	};
	
	public static Map<String,String> mapColumns = new HashMap<String,String>(){{
		put("jjyjdr",",jjzh,qyrq,fprq, hydh1,zlbl1,hydh2,zlbl2 ,hydh3,zlbl3 ,hydh4,zlbl4");
		put("bxyjdr", ",lsh,jyrq,fprq, hydh1,zlbl1,hydh2,zlbl2 ,hydh3,zlbl3 ,hydh4,zlbl4");
		put("dfgzyjdr", ",djbh,qyrq,fprq, hydh1,zlbl1,hydh2,zlbl2 ,hydh3,zlbl3 ,hydh4,zlbl4");
		put("dsfcgyjdr", ",khh,khmc,qyrq,fprq, hydh1,zlbl1,hydh2,zlbl2 ,hydh3,zlbl3 ,hydh4,zlbl4");
		put("dxtyjpldr", ",qykey,hth,khmc,qyrq,fprq, hydh1,zlbl1,hydh2,zlbl2 ,hydh3,zlbl3 ,hydh4,zlbl4");
		put("gjywyjdr", ",khh,khrq,fprq, hydh1,zlbl1,hydh2,zlbl2 ,hydh3,zlbl3 ,hydh4,zlbl4");
		put("kyjgxdr", ",kh,khkkrq,  qsrq, hydh1,zlbl1,hydh2,zlbl2 ,hydh3,zlbl3 ,hydh4,zlbl4,hydh5,zlbl5,hydh6,zlbl6 ,hydh7,zlbl7 ,hydh8,zlbl8,hydh9,zlbl9 ,hydh10,zlbl10");//
		put("lcyjdr", ",lsh,jyrq,fprq, hydh1,zlbl1,hydh2,zlbl2 ,hydh3,zlbl3 ,hydh4,zlbl4");
		
		put("POSShyjdr", ",shdh,qyrq,fprq, hydh1,zlbl1,hydh2,zlbl2 ,hydh3,zlbl3 ,hydh4,zlbl4");
		put("sjyhyjdr", ",qykey,hth,khmc,qyrq,fprq, hydh1,zlbl1,hydh2,zlbl2 ,hydh3,zlbl3 ,hydh4,zlbl4");
		put("wsyhyjdr", ",qykey,hth,khmc,qyrq,fprq, hydh1,zlbl1,hydh2,zlbl2 ,hydh3,zlbl3 ,hydh4,zlbl4");
		
		put("hyyjgxdrck",", zhdh, zhmc,zhye,khrq,qsrq, hydh1,zlbl1,hydh2,zlbl2 ,hydh3,zlbl3 ,hydh4,zlbl4,hydh5,zlbl5,hydh6,zlbl6 ,hydh7,zlbl7 ,hydh8,zlbl8,hydh9,zlbl9,hydh10,zlbl10");
		put("hyyjgxdrdk",", zhdh, zhmc,zhye,ffrq,qsrq, hydh1,zlbl1,hydh2,zlbl2 ,hydh3,zlbl3 ,hydh4,zlbl4,hydh5,zlbl5,hydh6,zlbl6 ,hydh7,zlbl7 ,hydh8,zlbl8,hydh9,zlbl9,hydh10,zlbl10");
		
		put("hyyjgxdrck1",", zhdh,zzh, zhmc,zhye,khrq,qsrq, hydh1,zlbl1,hydh2,zlbl2 ,hydh3,zlbl3 ,hydh4,zlbl4,hydh5,zlbl5,hydh6,zlbl6 ,hydh7,zlbl7 ,hydh8,zlbl8,hydh9,zlbl9,hydh10,zlbl10");
		put("hyyjgxdrdk1",", zhdh,zzh, zhmc,zhye,ffrq,qsrq, hydh1,zlbl1,hydh2,zlbl2 ,hydh3,zlbl3 ,hydh4,zlbl4,hydh5,zlbl5,hydh6,zlbl6 ,hydh7,zlbl7 ,hydh8,zlbl8,hydh9,zlbl9,hydh10,zlbl10");
		
		put("dkzryjdr",", zhdh,zzh, zhmc,zhye,ffrq,qsrq, hydh1,zlbl1,hydh2,zlbl2 ,hydh3,zlbl3 ,hydh4,zlbl4,hydh5,zlbl5,hydh6,zlbl6 ,hydh7,zlbl7 ,hydh8,zlbl8,hydh9,zlbl9,hydh10,zlbl10");
	}}; 
	
}
